I am trying to update table A with data from table B. I thought I could do
something like:
UPDATE A
SET A.name = B.name
WHERE A.id = B.id
FROM B
but alas, this does not work.
Anyone have an idea of how I can do this?
-Mark
----------------------------------------------------------------- Mark Lundquist mlundquist@bvsdps.com
-----------------------------------------------------------------